UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BuWngwJHlhwBj5YqxrDwHvoeK4TCjWxDC8unDZ+Jw0='
WHERE
key_id = '3e8293d3e3add27961b74d4f5a14b263416ad08b7a48c0e49ebeb6b840e6cb27'
AND (
token = '1BuWngwJHlhwBj5YqxrDwHvoeK4TCjWxDC8unDZ+Jw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)