UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOz3oaGNKwbMF+Ja+t05RY/eynWHrwSTCBARdweJmMU='
WHERE
key_id = '6794b9f304b004f3ae90125621e91d94bc59cc66afd27b2f2d5d9ebe236b60c3'
AND (
token = 'sOz3oaGNKwbMF+Ja+t05RY/eynWHrwSTCBARdweJmMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)