UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdrFcgqNSAaqY+pwcokhiLjHZ5vbBnfVNON7bz3tOno='
WHERE
key_id = '7bbae103014a78306a2685f90514a275bca16f22e0fb2951c01c960304a16a2b'
AND (
token = 'zdrFcgqNSAaqY+pwcokhiLjHZ5vbBnfVNON7bz3tOno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)