UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HKa3ar0fgtSDlAKaLK4UjrsgHwK0czHvPH//G+cpD1M='
WHERE
key_id = '46994b9ab579dd5b2432ba2feeadfd588c2fffbb6b2509d58087334e8b4f9a99'
AND (
token = 'HKa3ar0fgtSDlAKaLK4UjrsgHwK0czHvPH//G+cpD1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)