UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bxnlJ1q2YJCoSLp7oo8isKca6qdCJ2SOFZf2406ETG0='
WHERE
key_id = 'e110d65359b08ee602f0018e40b6c80c1cf7eb0d6fa126f8522462d66c95b1d5'
AND (
token = 'bxnlJ1q2YJCoSLp7oo8isKca6qdCJ2SOFZf2406ETG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)