UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWRBYc9ivtawhwEVa+K7kgxvOXC+DIej3VoG/iCnOvk='
WHERE
key_id = 'd7da5ee72db0ce84b921a59d7e6e4b157188a8f3f581688dfd1de4f37faa48f4'
AND (
token = 'pWRBYc9ivtawhwEVa+K7kgxvOXC+DIej3VoG/iCnOvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)