UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtLD2g/ocqlihzjNqUeK/PZ321VYn3fZuCFZNzdl85Y='
WHERE
key_id = 'e54c37902b237ef9a20c24b8a49ee20f32d0360b424f45f4341eebbc5369f855'
AND (
token = 'XtLD2g/ocqlihzjNqUeK/PZ321VYn3fZuCFZNzdl85Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)