UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hnax9i2IM1B24AFWyTLOLT4WfgP7R5cCLiptuo/P0RU='
WHERE
key_id = '8efddcfdaa4826266af7b6c0a54fd23c51a0746c0b6b73a6f7553d8deb7aad29'
AND (
token = 'hnax9i2IM1B24AFWyTLOLT4WfgP7R5cCLiptuo/P0RU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)