UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVqiSAI2B1pMAln6to1uVONXbaxS+m3ZahA4LENUsuY='
WHERE
key_id = '6f48f25c01e4fd71e0759fc175bad14af6b59cb789300b188704c769f7cd78d9'
AND (
token = 'ZVqiSAI2B1pMAln6to1uVONXbaxS+m3ZahA4LENUsuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)