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