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