UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e8NIKVj/ZnlW0q6hcj0pUL/bHpyCaUtmpQhgY4olMhA='
WHERE
key_id = '3ab6b15ede124e9dc45c313fb75fb29b17619bbbe72f2c31d20b62bb5050d07b'
AND (
token = 'e8NIKVj/ZnlW0q6hcj0pUL/bHpyCaUtmpQhgY4olMhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)