UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEXCT1cHU0U2jL3Cu0/iC40KP1nWhkz2615gSLmgfME='
WHERE
key_id = 'eac185e3c09f3d11ee3805b5d3119fc0556c618320e8ccf0c4f9441185270b41'
AND (
token = 'oEXCT1cHU0U2jL3Cu0/iC40KP1nWhkz2615gSLmgfME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)