UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fpy/JhWKx6Sx91uQERr/gYh/vAqqL1QD4RBTB75eeJw='
WHERE
key_id = '7cfa954abc317e85b6f8f1a7a91a306460a555ae1a938b7700876749eceaed1c'
AND (
token = 'fpy/JhWKx6Sx91uQERr/gYh/vAqqL1QD4RBTB75eeJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)