UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5an8k/gZODieFDecq3hRTDMlBYZLfVS8jimJNh02d4M='
WHERE
key_id = '1417b0e7f813a47f2b6b6eca6258b514c71174bb9bec4d93cf6a2f5c347f8d13'
AND (
token = '5an8k/gZODieFDecq3hRTDMlBYZLfVS8jimJNh02d4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)