UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XAIdvDPeFqae31/9HCn8fthiOq5cyQIbWxQJLxNvvI='
WHERE
key_id = 'd34d32657ccc616c9f0b6ea503bc29e4da463c829292d10a0575d77dc3e9ac3e'
AND (
token = '7XAIdvDPeFqae31/9HCn8fthiOq5cyQIbWxQJLxNvvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)