UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mgfN/TR9pKn1B8J06Zexc4xQTlBdFHWGfuaVoE1S1X8='
WHERE
key_id = '378eb5ce551448ff35ad84e39b4a31da14010834cf3c33951b95aba098fff93a'
AND (
token = 'mgfN/TR9pKn1B8J06Zexc4xQTlBdFHWGfuaVoE1S1X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)