UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zq3VJtpRxrRe7cLokUcqFVEV2P618c1rZpPS3AMU7dY='
WHERE
key_id = '9a41a2a3297e7b6731b132b8950ea1e0efd06ca77b2130a843eda0a0f888e8fd'
AND (
token = 'Zq3VJtpRxrRe7cLokUcqFVEV2P618c1rZpPS3AMU7dY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)