UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zz046h91R7IiDAWelkPiK82aBUGBBDuqeGz7f7mAGK8='
WHERE
key_id = 'd02623f64753cf43a65b97fcee743049b70d40071956aabb2b09ffb0d6766e70'
AND (
token = 'zz046h91R7IiDAWelkPiK82aBUGBBDuqeGz7f7mAGK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)