UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8TVaRo6+hLp3OHJbi5lbPPQNJ2PYJVxiTLnJztJfZeg='
WHERE
key_id = '46d6231a835778dec87f9eec22c4f49f33c4c4ca140f58c6c0003501469c7a21'
AND (
token = '8TVaRo6+hLp3OHJbi5lbPPQNJ2PYJVxiTLnJztJfZeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)