UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lC6j2udLzGEYtm6RZCFF+8NVDjE8WGp+nXbT262+LJ0='
WHERE
key_id = '9a8044814a2efa4a0ed87257184722fb9fc28e8caf5a0bd0be502cda9dbbdae8'
AND (
token = 'lC6j2udLzGEYtm6RZCFF+8NVDjE8WGp+nXbT262+LJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)