UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pTmYuIjy2wCgxRwsC62uCy9CFLmcSviUi+TI3PNVoHM='
WHERE
key_id = 'b643822b4ac66d38399db0cbf6e758d25e28a1585d7b728a2e2ae0937b852ac0'
AND (
token = 'pTmYuIjy2wCgxRwsC62uCy9CFLmcSviUi+TI3PNVoHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)