UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'u7foW+g855DQzl4VAgYCvusfA1AaS9gqgOwt8S8SyVM=' 
WHERE 
  key_id = '7cbaeab73a064e346bc44b72ecfc95f2d039951628d6664a07d8c7c0750958d5' 
  AND (
    token = 'u7foW+g855DQzl4VAgYCvusfA1AaS9gqgOwt8S8SyVM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045