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

Query time 0.00030