UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zh8G/b0egdiAtq72xyIFQ/ybcm2xORBKkMEPcNeMua0='
WHERE
key_id = '24fa86da85a2e52283e1bc2924ccc16a8d7477e1f54b43830e7c3776701482e6'
AND (
token = 'zh8G/b0egdiAtq72xyIFQ/ybcm2xORBKkMEPcNeMua0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)