UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UKjhfp7+NeQJIsUTG9dSamnBJTuCzr6wnSB4t/ed14w='
WHERE
key_id = 'c9d715ce920be4ab0f6f62a7255042d2c6bfe2c71d9e6292f9c01553bf424892'
AND (
token = 'UKjhfp7+NeQJIsUTG9dSamnBJTuCzr6wnSB4t/ed14w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)