UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tTDRl6FmRQ9iWZcLQDaK1fhwUCxd1oGJ5W7feOZoe0='
WHERE
key_id = 'ff42ef2211b9a24481f9dad6ca5691314642d8c4ad49e5561ef21b00c53e5e6b'
AND (
token = '8tTDRl6FmRQ9iWZcLQDaK1fhwUCxd1oGJ5W7feOZoe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)