UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cYPX5vM9nSFKD77R4h4PVVxBJVUVVVYeXb6jJqMGmTo='
WHERE
key_id = '7e98e65eb0182e947bf991fda5ae65c74eaa95574e572453a2efd02c20685a12'
AND (
token = 'cYPX5vM9nSFKD77R4h4PVVxBJVUVVVYeXb6jJqMGmTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)