UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aThFcXdZpIq+3uwO31NcBKr/qE2II25s82C0F0Z0YKc=' 
WHERE 
  key_id = 'bafa3554cc7da9af630c5611f533dea994e790822a864510b5e2a379c26b1f20' 
  AND (
    token = 'aThFcXdZpIq+3uwO31NcBKr/qE2II25s82C0F0Z0YKc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021