UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eftGZxaTMYlf7qyEAtBpvC2zmbV46nbM1CWrt/x3RuY='
WHERE
key_id = '669e67385d45bcf412eb0ff6297c0596a4cb229cafa3975eb55afbeeac9ed18a'
AND (
token = 'eftGZxaTMYlf7qyEAtBpvC2zmbV46nbM1CWrt/x3RuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)