UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'c8t5UpceRKfGujnt8DwfyEgnsGElK2nZnZnYTDeSpjg=' 
WHERE 
  key_id = '67c5f36f84c8f38c97ca3530919292417f99c22b133e1a6e81227d28da42999c' 
  AND (
    token = 'c8t5UpceRKfGujnt8DwfyEgnsGElK2nZnZnYTDeSpjg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025