UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZSMAwyeiyxlC/WzI+yum/apQp8mwrAGImbEPdap9R0g='
WHERE
key_id = '7fdb4b1d493ac0988b3a85236b9dfefa29ad2144809048b8f2ae18660a5bc3b9'
AND (
token = 'ZSMAwyeiyxlC/WzI+yum/apQp8mwrAGImbEPdap9R0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)