UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AiHaRBPjw63m4HaP5YY9SEQTrNjgnr4RnNSpxcOHAM4='
WHERE
key_id = '1a8b1febf1f45ae9b95541fefb169b84a7af56d86504736a4ce9d4420fbfa296'
AND (
token = 'AiHaRBPjw63m4HaP5YY9SEQTrNjgnr4RnNSpxcOHAM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)