UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1Xt30jHNRj2MKk4JC+n4PFg1qJ27snHt9LDfP6JG4KU=' 
WHERE 
  key_id = 'e4b39fc72844fe9b83434de681c93d1afc9bf7e49807f9236f84d308819149c1' 
  AND (
    token = '1Xt30jHNRj2MKk4JC+n4PFg1qJ27snHt9LDfP6JG4KU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022