UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kKHFIq0J8n8LPaHEj+L8UMgD7ha6VuIkas/aJk5DfzA=' 
WHERE 
  key_id = 'f2b0a8f227e6a8315a456e29fb2c2667a86c089eee2a6c25586260c6d63bee4d' 
  AND (
    token = 'kKHFIq0J8n8LPaHEj+L8UMgD7ha6VuIkas/aJk5DfzA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042