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