UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fboS03aTIFyLqpgW22xZxBU0t8CHk0qCjHJkjvsYSUc='
WHERE
key_id = 'a04b8c221c48b15789acc256950dfaa279d21a5c9d8bdca8dcf75a98bf63bc13'
AND (
token = 'fboS03aTIFyLqpgW22xZxBU0t8CHk0qCjHJkjvsYSUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)