UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w6tR3hkDHV7iYrxNiWm/tennV/7sXC1K/esoLZcbrks='
WHERE
key_id = 'f63a0aec1c03b87ecc5e89337c9236221607e363c85c32202b2600dc800ebd4a'
AND (
token = 'w6tR3hkDHV7iYrxNiWm/tennV/7sXC1K/esoLZcbrks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)