UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lQLK6f+QwQudg/VA5FZ4JW/g/11wockuT+nE7y4VkUM=' 
WHERE 
  key_id = 'b66496f3dcc86906c587fb00ceb7f97ee7763af53c24994a5a8e7117ce7804de' 
  AND (
    token = 'lQLK6f+QwQudg/VA5FZ4JW/g/11wockuT+nE7y4VkUM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031